این قسمت صفحه اصلی برنامه هست که میاد اطلاعات دیگر رو با اشاره کردن به همدیگه ادامه میده منتهی start کار از اینجاست:
کد HTML:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<%
if (Request["user"] != null && Request["pass"] != null)
{
string con, com;
bool found = false;
con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Request.PhysicalApplicationPath + @"data.mdb";
OleDbConnection olcon = new OleDbConnection(con);
com = "select * from data";
OleDbCommand olcom = new OleDbCommand(com, olcon);
OleDbDataReader olreader;
olcon.Open();
olreader = olcom.ExecuteReader();
while (olreader.Read())
{
if (olreader["inuser"].ToString() == Request["user"] && olreader["inpass"].ToString() == Request["pass"])
{
found = true;
}
}
olreader.Close();
olcon.Close();
if (found == true)
{
Session["user"] = Request["user"];
Session["log"] = "yes";
Response.Redirect("show1.aspx");
}
else
{
Response.Redirect("default.aspx?msg=wrong username or password&wronguser=" + Request["user"]);//در اینجا وقتی این قسمت اجرا میشه چون بهش گفتیم بیا اونی که در یوزر نوشتیم رو حفظ کن میاد و برامون نگه میداره
}
}
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Default</title>
</head>
<body >
<form id="form1" runat="server">
<div align="center" style="height:100%">
<div style="border-style:groove; border-color:Blue; border-width:inherit" >
<p style="color:Fuchsia; font-size:small>
<form action="Default.aspx" method="get">
<br />
username: <input type="text" name="user" value="<%= Request["wronguser"] %>" />
<br />
password:<input type="text" name="pass" />
<br />
<%
if (Request["wp"]!=null)
{
Response.Write("<input type=\"hidden\" value\"" + Request["wp"] + " \" />");
}
%>
<input type="reset" value="again" />
<input type="submit" value="Enter" />
<br />
<p style="font-size:small; color:Red">
<%= Request["msg"] %>
</p>
<span style="font-size:small; color:Blue">
<a href="newuser.aspx">
new user or add user
</a>
<br />
guest:<%=(Application["guest"].ToString()) %>
<br />
users:<%=(Application["user"].ToString()) %>
<br />
user online:<%=(Application["online"].ToString()) %>
<br />
all user:<%=(Application["allvisit"].ToString()) %>
<br />
</span>
</form>
</p>
</div>
</div>
</form>
</body>
</html>
این قسمت طراحی برای ثبت نام افراد و همینطور عملیات اضافه کردن در لیست رو انجام میده:
کد HTML:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<%
if (Request["nuser"] != null && Request["npass"] != null)
{
string strcon, strcom, strinsert;
bool tekrari = false;
strcom = "select * from data";
strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Request.PhysicalApplicationPath + @"data.mdb";
OleDbConnection con = new OleDbConnection(strcon);
OleDbCommand com = new OleDbCommand(strcom, con);
OleDbDataReader olresder;
con.Open();
olresder = com.ExecuteReader();
while (olresder.Read())
{
if (olresder["inuser"].ToString() == Request["nuser"].ToString())
{
tekrari = true;
}
}
olresder.Close();
con.Close();
if (tekrari == true)
{
Response.Redirect("newuser.aspx?msg=username is reapet...!!!!");
}
else
{
strinsert = string.Format("INSERT INTO data(inuser,inpass)VALUES('{0}','{1}')", Request["nuser"], Request["npass"]);
com.CommandText = strinsert;
con.Open();
com.ExecuteNonQuery();
con.Close();
Response.Redirect("default.aspx?msg=new user added and now can login");
}
}
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>new user</title>
</head>
<body >
<form id="form1" runat="server">
<div style="border-style:double; border-width:medium;border-color:Aqua>
<p style="color:Green; font-size:small>
new user page
</p>
<form action="newuser.aspx" method="get">
<br />
Username:
<input type="text" name="nuser" /><br />
<br />
Password:
<input type="password" name="npass" /><br />
<br />
<input type="reset" value="again" />
<input type="submit" value="make new user" /><br />
<p style="color: Red; font-size: small">
<%= Request["msg"] %>
</p>
<span style="color: Red; font-size: small">
<a href="default.aspx">Enter the page</a><br /><br />
</span>
</form>
</div>
</form>
</body>
</html>
این قسمت برای ویرایش لیست نوشته شده:
کد HTML:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<%
if (Session["log"]!="yes")
{
Response.Redirect("default.aspx?msg=u don't login");
}
else
{
Response.Cache.SetNoStore();
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetExpires(DateTime.MinValue);
}
if (Request["pssold"]!=null&&Request["pssnew"]!=null)
{
string strcom,strcon;
bool ok=false;
strcon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Request.PhysicalApplicationPath + @"data.mdb";
strcom="select * from data";
OleDbConnection olcon=new OleDbConnection(strcon);
OleDbCommand olcom=new OleDbCommand(strcom,olcon);
OleDbDataReader olreader;
olcon.Open();
olreader=olcom.ExecuteReader();
while (olreader.Read())
{
if (olreader["inuser"].ToString() == Session["user"].ToString() && olreader["inpass"].ToString() == Request["pssold"].ToString())
ok = true;
}
olreader.Close();
olcon.Close();
if (ok == false)
Response.Redirect("edit.aspx?msg=passworde ghadimi ba usere shoma hamkhani nadarad");
else
{
strcom =string.Format("UPDATE data SET inpass='{0}' where inuser='{1}'", Request["pssnew"], Session["user"]);
olcom.CommandText = strcom;
olcon.Open();
olcom.ExecuteNonQuery();
olcon.Close();
Response.Redirect("edit.aspx?msg=passworde shoma jaigozin shod");
}
}
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body >
<form id="form1" runat="server">
<div align="center">
<div style="border-color:Silver;border-width:medium;border-style:inset">
<p style="color:Fuchsia">
edit user page
</p>
<span style="color:Yellow;font-size:medium">
change password for user <%= Session["inuser"] %>
</span>
<br />
<span style="color:Blue;font-size:medium">
<form action="edit.aspx" method="get">
<br />
old password:
<input type="password" name="pssold" />
<br />
new password:
<input type="password" name="pssnew" />
<br />
</span>
</form>
<input type="reset" value="again" />
<br />
<input type="submit" value="change password"/>
<br />
<p style="font-size:larger;color:Red">
<%= Request["msg"] %>
</p>
<span style="color:Fuchsia;font-size:medium">
<a href="show1.aspx">SHOW ONE</a>
<a href="show2.aspx">SHOW TWO</a>
<a href="logout.aspx">LOGOUT</a>
</span>
</div>
</div>
</form>
</body>
</html>
این قسمت برای نمایش افراد آنلاین در محیط برنامه :
کد HTML:
<%@ Application Language="C#" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
void Application_Start(object sender, EventArgs e)
{
Application["allvisit"] = 0;
Application["online"] = 0;
Application["guest"] = 0;
Application["user"] = 0;
}
void Application_End(object sender, EventArgs e)
{
// Code that runs on application shutdown
}
void Application_Error(object sender, EventArgs e)
{
// Code that runs when an unhandled error occurs
}
void Session_Start(object sender, EventArgs e)
{
string connect, commandformat, commandformat2;
// connect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Request.PhysicalApplicationPath + @"Databasealaki.accdb";
connect = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Request.PhysicalApplicationPath + @"data.mdb";
commandformat = "Select * from bazdid";
OleDbConnection olconnect = new OleDbConnection(connect);
OleDbCommand olcom = new OleDbCommand(commandformat, olconnect);
OleDbDataReader olreader;
olconnect.Open();
olreader = olcom.ExecuteReader();
while (olreader.Read())
{
Application["allvisit"] = olreader["id"];
}
olconnect.Close();
Application["allvisit"] = (int)Application["allvisit"] + 1;
Application["online"] = (int)Application["online"] + 1;
Application["guest"] = (int)Application["guest"] + 1;
commandformat2 = "Insert InTo bazdid (afiled) Values (' ')";
OleDbCommand olcom2 = new OleDbCommand(commandformat2, olconnect);
olconnect.Open();
olcom2.ExecuteNonQuery();
olconnect.Close();
}
void Session_End(object sender, EventArgs e)
{
Application["online"] = (int)Application["online"] - 1;
if (Session["user"].ToString() != "yes")
{
Application["guest"] = (int)Application["guest"] - 1;
}
else
{
Application["user"] = (int)Application["user"] - 1;
}
}
</script>
این قسمت برای خارج شدن از برنامه:
کد HTML:
<%@ Page Language="C#" %>
<%
Session.Abandon();
Response.Redirect("default.aspx");
%>
این قسمت یک صفحه نمایشی است که میاد مثلا بهش ارجاع داده میشه:
کد HTML:
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<%
if (Session["log"]!="yes")
{
Response.Redirect("default.aspx?msg=you don't login");
}
else
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetNoStore();
Response.Cache.SetExpires(DateTime.MinValue);
}
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>show one</title>
</head>
<body>
<form id="form1" runat="server">
<div align="center" >
<div style="border-style:dashed; border-width:thick;border-color:Blue>
<p style="color:Black; font-size:medium>
hi .... new user:) ==> how are you?
<span style="color:Gray; font-size:larger>
<%= Session["user"] %>
</span>
<br />
thanks of come to this page :)
<br /><br /><br />
<a href="edit.aspx">EDIT</a>
<a href="logout.aspx">EXIT</a>
<a href="show2.aspx">SHOW NEXT PAGE</a>
</p>
<br /><br />
</div>
</div>
</form>
</body>
</html>
این قسمت هم یک صفحه نمایش دیگه هست که بهش ارجاع داده میشه:
کد HTML:
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<%
if (Session["log"]!="yes")
{
Response.Redirect("default.aspx?msg=u don't login");
}
else
{
Response.Cache.SetNoStore();
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetExpires(DateTime.MinValue);
}
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>SHOW TWO</title>
</head>
<body>
<form id="form1" runat="server">
<div align="center">
<div style="border-style:inherit; border-color:Gray; border-width:thick">
<p style="color:Blue;size:landscape>
SHOW PAGE TWO
</p>
<br />
<p style="color:Blue; direction:rtl;size:portrait>
HI DEAR USER
</p>
<span style="color:Aqua;font-size:larger">
<%= Session["user"] %>
</span>
<br /><br />
this page is two pages
<br /><br /><br />
<a href="show1.aspx">SHOW ONE PAGE</a>
<a href="logout.aspx">EXIT</a>
<a href="edit.aspx">EDIT</a>
</div>
</div>
</form>
</body>
</html>
سوالی بود بفرمایین
بااحترام
موضوعات مشابه:
LinkBack URL
About LinkBacks
پاسخ با نقل قول
علاقه مندی ها (Bookmarks)